-- ----------------------------
-- Table structure for ums_member
-- ----------------------------
DROP TABLE IF EXISTS `ums_member`;
CREATE TABLE `ums_member` (
      `id` bigint(20) NOT NULL AUTO_INCREMENT,
      `username` varchar(64) NOT NULL DEFAULT '' COMMENT '用户名',
      `password` varchar(64) NOT NULL DEFAULT '' COMMENT '密码',
      `nickname` varchar(64) NOT NULL DEFAULT '' COMMENT '昵称',
      `phone` varchar(64) NOT NULL DEFAULT '' COMMENT '手机号码',
      `status` int(1) NOT NULL DEFAULT '1' COMMENT '帐号启用状态:0->禁用；1->启用',
      `icon` varchar(500) NOT NULL DEFAULT '' COMMENT '头像',
      `gender` int(1) NOT NULL DEFAULT '0' COMMENT '性别：0->未知；1->男；2->女',
      `birthday` date NOT NULL DEFAULT '1970-01-01' COMMENT '生日',
      `city` varchar(64) NOT NULL DEFAULT '' COMMENT '所在城市',
      `personalized_signature` varchar(200) NOT NULL DEFAULT '' COMMENT '个性签名',
      `source_type` int(1) NOT NULL DEFAULT '0' COMMENT '用户来源',
      `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '注册时间',
      `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
      `is_del` tinyint(1) NOT NULL DEFAULT '0' COMMENT '删除状态 0 - 正常 1- 删除',
      PRIMARY KEY (`id`),
      UNIQUE KEY `idx_username` (`username`),
      UNIQUE KEY `idx_phone` (`phone`)
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8 COMMENT='会员表';

-- ----------------------------
-- Records of ums_member
-- ----------------------------
BEGIN;
INSERT INTO `ums_member` VALUES (10, 'weylan', '$2a$10$wYJ0.jcOVkbM76.A8bVQhu03kF0mBXZRCyGxjtO.l69y3f0QGknqu', 'weylan', '133', 1, 'http://test.jpg', 0, '1970-01-01', '', '', 0, '2021-05-17 17:45:10', '2021-05-18 10:26:02', 0);
COMMIT;